//add fcounty for PA, 2012
// fips codes accessed here: https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697
gen fcounty=.
replace fcounty=1 if county=="ADAMS " & state=="Pennsylvania"
replace fcounty=3 if county=="ALLEGHENY " & state=="Pennsylvania"
replace fcounty=5 if county=="ARMSTRONG " & state=="Pennsylvania"
replace fcounty=7 if county=="BEAVER " & state=="Pennsylvania"
replace fcounty=9 if county=="BEDFORD " & state=="Pennsylvania"
replace fcounty=11 if county=="BERKS " & state=="Pennsylvania"
replace fcounty=13 if county=="BLAIR " & state=="Pennsylvania"
replace fcounty=15 if county=="BRADFORD " & state=="Pennsylvania"
replace fcounty=17 if county=="BUCKS " & state=="Pennsylvania"
replace fcounty=19 if county=="BUTLER " & state=="Pennsylvania"
replace fcounty=21 if county=="CAMBRIA " & state=="Pennsylvania"
replace fcounty=23 if county=="CAMERON " & state=="Pennsylvania"
replace fcounty=25 if county=="CARBON " & state=="Pennsylvania"
replace fcounty=27 if county=="CENTRE " & state=="Pennsylvania"
replace fcounty=29 if county=="CHESTER " & state=="Pennsylvania"
replace fcounty=31 if county=="CLARION " & state=="Pennsylvania"
replace fcounty=33 if county=="CLEARFIELD " & state=="Pennsylvania"
replace fcounty=35 if county=="CLINTON " & state=="Pennsylvania"
replace fcounty=37 if county=="COLUMBIA " & state=="Pennsylvania"
replace fcounty=39 if county=="CRAWFORD " & state=="Pennsylvania"
replace fcounty=41 if county=="CUMBERLAND " & state=="Pennsylvania"
replace fcounty=43 if county=="DAUPHIN " & state=="Pennsylvania"
replace fcounty=45 if county=="DELAWARE " & state=="Pennsylvania"
replace fcounty=47 if county=="ELK " & state=="Pennsylvania"
replace fcounty=49 if county=="ERIE " & state=="Pennsylvania"
replace fcounty=51 if county=="FAYETTE " & state=="Pennsylvania"
replace fcounty=53 if county=="FOREST " & state=="Pennsylvania"
replace fcounty=55 if county=="FRANKLIN " & state=="Pennsylvania"
replace fcounty=57 if county=="FULTON " & state=="Pennsylvania"
replace fcounty=59 if county=="GREENE " & state=="Pennsylvania"
replace fcounty=61 if county=="HUNTINGDON " & state=="Pennsylvania"
replace fcounty=63 if county=="INDIANA " & state=="Pennsylvania"
replace fcounty=65 if county=="JEFFERSON " & state=="Pennsylvania"
replace fcounty=67 if county=="JUNIATA " & state=="Pennsylvania"
replace fcounty=69 if county=="LACKAWANNA " & state=="Pennsylvania"
replace fcounty=71 if county=="LANCASTER " & state=="Pennsylvania"
replace fcounty=73 if county=="LAWRENCE " & state=="Pennsylvania"
replace fcounty=75 if county=="LEBANON " & state=="Pennsylvania"
replace fcounty=77 if county=="LEHIGH " & state=="Pennsylvania"
replace fcounty=79 if county=="LUZERNE " & state=="Pennsylvania"
replace fcounty=81 if county=="LYCOMING " & state=="Pennsylvania"
replace fcounty=83 if county=="MCKEAN " & state=="Pennsylvania"
replace fcounty=85 if county=="MERCER " & state=="Pennsylvania"
replace fcounty=87 if county=="MIFFLIN " & state=="Pennsylvania"
replace fcounty=89 if county=="MONROE " & state=="Pennsylvania"
replace fcounty=91 if county=="MONTGOMERY " & state=="Pennsylvania"
replace fcounty=93 if county=="MONTOUR " & state=="Pennsylvania"
replace fcounty=95 if county=="NORTHAMPTON " & state=="Pennsylvania"
replace fcounty=97 if county=="NORTHUMBERLAND " & state=="Pennsylvania"
replace fcounty=99 if county=="PERRY " & state=="Pennsylvania"
replace fcounty=101 if county=="PHILADELPHIA " & state=="Pennsylvania"
replace fcounty=103 if county=="PIKE " & state=="Pennsylvania"
replace fcounty=105 if county=="POTTER " & state=="Pennsylvania"
replace fcounty=107 if county=="SCHUYLKILL " & state=="Pennsylvania"
replace fcounty=109 if county=="SNYDER " & state=="Pennsylvania"
replace fcounty=111 if county=="SOMERSET " & state=="Pennsylvania"
replace fcounty=113 if county=="SULLIVAN " & state=="Pennsylvania"
replace fcounty=115 if county=="SUSQUEHANNA " & state=="Pennsylvania"
replace fcounty=117 if county=="TIOGA " & state=="Pennsylvania"
replace fcounty=119 if county=="UNION " & state=="Pennsylvania"
replace fcounty=121 if county=="VENANGO " & state=="Pennsylvania"
replace fcounty=123 if county=="WARREN " & state=="Pennsylvania"
replace fcounty=125 if county=="WASHINGTON " & state=="Pennsylvania"
replace fcounty=127 if county=="WAYNE " & state=="Pennsylvania"
replace fcounty=129 if county=="WESTMORELAND " & state=="Pennsylvania"
replace fcounty=131 if county=="WYOMING " & state=="Pennsylvania"
replace fcounty=133 if county=="YORK " & state=="Pennsylvania"


